Preparing the Printout
Notes on the Page Setup

Headers and footers are printed at the upper and lower page margins. Select Page Setup on the File menu. Make the settings in the Page Setup dialog box.

Headers and footers can contain text and specific format codes. The syntax is compatible with Microsoft Excel. Observe the order of the single entries. First, define the alignment of the single header and/or footer, using one of the following commands:

 

&L

Left-aligns the characters that follow

&C

Centers the characters that follow (default)

&R

Right-aligns the characters that follow

 

The default font is Arial 10. You can only define a different font after you have defined the header and/or footer alignment. Define the new font as follows:

 

&B

Bold

&I

Italic

&U

Underline

&S

Strikeout

&"fontname"

Uses the specified font

&nn

Uses the specified font size

 

 Tip:

If you do not enter these font definitions after the header and/or footer alignment, they will be ignored. You can change the font after each alignment code (&l/&C/&R).

Finally, enter the expression to be printed:

 

&A

Prints the current sheet name

&D

Prints the current date

&T

Prints the current time

&F

Prints the Report Definition File (RDF)

&P

Prints the page number

&P+Number

Prints the following page number: current page + entered number. For example: &P+4 prints page 16 if the current page is page 12 and you entered 4.

&&

Prints an ampersand

&N

Prints the total number of pages in the document

 

When entering headers and footers longer than one line, note that the alignment codes (&L,&C,&R) must be column-oriented. Enter all left-aligned rows first, then enter all centered rows, and finally enter all right-aligned rows. To separate rows, press <Ctrl> <Enter>.

In addition to the pre-defined variables above, you can enter variables pertaining to Chromeleon. Enclose these variables in braces.

Example:

&LOperator: {gen.operator} , Timebase: {seq.timebase} , Sequence:{seq.name} &RPage &P of &N

&D

This example produces the following header or footer

 

Operator: cmadmin, Timebase: HPLC, Sequence: Calibration

Page 1 of 12

 

4/6/2002

 

You can include any Chromeleon variable in the header. However, including sample and sequence variables makes the most sense. The Chromeleon formula variables are identical with the ones generated in the dialog box for entering report variables. Enter the decimal places for numerical variables after the formula. Separate them by ";" (default: 0). Example: {smp.inject_volume;2}. Time entries cannot be formatted.

 

 Note:

All worksheets of the Printer Layout that are selected for printing are considered one single print job; that is, page numbering is consecutive for all worksheets.